<%@ page import="controllers.SolutionConnect" %>
<%@ page import="models.SolutionSubmission" %>
<%@ page import="models.SolutionAdoption" %>
<%@ page import="java.text.*,java.util.*"%>
<%@ page import="java.util.HashMap" %>
<%@ page import="com.googlecode.objectify.Objectify" %>
<%@ page import="com.googlecode.objectify.ObjectifyService" %>
<%@ page import="com.googlecode.objectify.Query" %>
<%@ page import="controllers.CommonConnect"%>

<% 
    int i =0;
    long awd_id = 0;
    String optionName ="";
    SimpleDateFormat dt1 = new SimpleDateFormat("MM/dd/yyyy");
    Date today = new java.util.Date();
    String DisplayDate =  dt1.format(today);
    long optionValue =0;
    String user_email1 = (String) pageContext.getAttribute("USER_EMAILID", PageContext.PAGE_SCOPE);
    CommonConnect NOM = new CommonConnect();
    List<HashMap<String,Object>> rsArea = NOM.GetArea();
    List<HashMap<String,Object>> rsCustomerrsArea = NOM.getCustomer();
    List<HashMap<String,Object>> rsSite = NOM.GetLocation();
%>

<div id="lotusContent">
<!--<h1>Savvy Solutions</h1>
<div class="lotusDetails">The Global Operations Excellence collection of Savvy Solutions resulting in cost savings for the company</div>-->
<br>
<table>
<tr>
<td colspan="3"><div style="font-size:10"><b>Filter By : </b></div></td>
</tr>
<tr>
<td> Customer : </td><td><select id="cmbCustomer"  class="text-edit">
<option>--Select Customer--</option>
<%
                        i = 0;
                        while ( i < rsCustomerrsArea.size() ) {
                        	optionName = (String) rsCustomerrsArea.get(i).get("CustName");
                    %>

                    <option value="<%=optionName%>"> <%=optionName%></option>
                    <%
                            i++;
                        }
                        optionName = "";
                    %>
</select></td>
 <td></td>
</tr>
<tr>
<td> Location : </td><td><select id="cmbLocation"  class="text-edit">
<option>--Select Location--</option>
<%
	                        i = 0;
	                        while ( i < rsSite.size() ) {
	                            optionName = (String) rsSite.get(i).get("LocationName");
	                    %>
	
	                    <option value="<%=optionName%>"> <%=optionName%></option>
	                    <%
	                            i++;
	                        }
	                        optionName = "";
	                    %>
</select> </td><td></td>
</tr>
<tr>
<td> Process : </td><td colspan="2"><select id="cmbProcessarea"  class="text-edit">
<option>--Select Process Area--</option>
<%
                        i = 0;
                        while ( i < rsArea.size() ) {
                            optionName = (String) rsArea.get(i).get("AreaName");
                    %>

                    <option value="<%=optionName%>"> <%=optionName%></option>
                    <%
                            i++;
                        }
                        optionName = "";
                    %>
</select> </td>
</tr>
<td> Solution Type: </td><td><select id="cmbSolType"  class="text-edit">
<option>--Select Solution Type--</option>
<option>Kaizen</option>, <option>Six Sigma</option>, <option>Other</option></select> </td><td></td>
</tr>
<tr>
<td>Financial Benefit :</td><td><select id="cmbFinBenfit"  class="text-edit">
<option>--Select Financial Benefit--</option><option>Hard Savings</option>, <option>Cost Avoidance</option>, <option>Opportunity Costs</option></select></td><td></td>
</tr>
<tr>
<td>Achieved Benefit :</td><td><select id="cmbAchBenfit"  class="text-edit">
<option>--Select Achieved Benefit--</option><option>Safety</option>, <option>Quality</option>, <option>Order Lead Time</option>, <option>Customer satisfaction</option>, <option>Employee engagement</option></select></td><td></td>
</tr>
<tr>
<td style="vertical-align: bottom;"> Posted Date : </td><td>From:&nbsp;&nbsp;<input type="text" name="fromDt" width="2"> <A 
                        onmouseover="window.status='Click here to select date from calender';return true;" 
onclick='showCalendar(this, document.forms[0].fromDt, "mm/dd/yyyy","en",1)'
                        onmouseout="window.status='';return true;" href="javascript:;"><img src="/img/bx.gif" width="16" height="15" alt="Select Date" border="0"></a></td>
<td>To:&nbsp;&nbsp;<input type="text" name="toDt"><A 
                        onmouseover="window.status='Click here to select date from calender';return true;" 
onclick='showCalendar(this, document.forms[0].toDt, "mm/dd/yyyy","en",1)'
                        onmouseout="window .status='';return true;" href="javascript:;"><img src="/img/bx.gif" width="16" height="15" alt="Select Date" border="0"></a></td>
</tr>
<tr><td></td><td></td><td></td><td></td></tr>
<tr><td><span class="lotusBtn lotusBtnAction lotusLeft">
<a href="javascript:Searchdocs()"><b>Show</b></a>
</span></td>
<td colspan="2"><span class="lotusBtn lotusBtnAction lotusLeft">
<a href="javascript:ClearAll()"><b>Clear</b></a>
</span></td>
</tr>
</td></tr>
</table><br>
<table>
<tr><td colspan="2"><span class="lotusBtn lotusBtnAction lotusLeft">
<!--- <a href="/global/collaboration/savvysol.nsf/agtmpscandidate?openagent&" ><b>Rem MPS Candidate</b></a>  --->
<a href="javascript:RemoveMPSCandidate()"><b>Remove MPS Candidate</b></a>
</span></td></tr>
</table>
<br>
<br>
<div id='view'>
<b>Please wait...<img src="/img/ajax-loader.gif">...while your request is processed.</b>
</div>
<br>
</div>
<!--End of Lotus Content-->
</div>
<!--End of Lotus Main-->
</div>
<!-- Footer gets moved to within Frame div in weblog.vm so closing tags need to go in weblog.vm - MTodd November 1 2007 </body> </html> -->
</div>
</div>